{
  "properties" : { },
  "id" : "9b8b9f5768ba49dca2ed22d4f0ebe900",
  "script" : null,
  "groupId" : "ee26ca5b190e44bfaa7bc7a3ad950442",
  "name" : "db",
  "createTime" : null,
  "updateTime" : 1706756917384,
  "lock" : null,
  "createBy" : null,
  "updateBy" : null,
  "path" : "db",
  "method" : "GET",
  "parameters" : [ ],
  "options" : [ ],
  "requestBody" : "",
  "headers" : [ ],
  "paths" : [ ],
  "responseBody" : "{\n    \"code\": 1,\n    \"message\": \"success\",\n    \"data\": [\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"S3\",\n            \"tableName\": \"T_USER\",\n            \"tableType\": \"STANDARD_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": \"CREATE CACHED TABLE S3.T_USER(\\n    ID INTEGER DEFAULT (NEXT VALUE FOR S3.SYSTEM_SEQUENCE_EA76BAD0_C9AE_4FA0_A778_29C57FD1F275) NOT NULL NULL_TO_DEFAULT SEQUENCE S3.SYSTEM_SEQUENCE_EA76BAD0_C9AE_4FA0_A778_29C57FD1F275,\\n    NAME VARCHAR(100),\\n    AGE TINYINT,\\n    CREATE_TIME TIMESTAMP\\n)\",\n            \"remarks\": \"\",\n            \"lastModification\": 0,\n            \"id\": 7,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.StandardTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"INFORMATION_SCHEMA\",\n            \"tableName\": \"FUNCTION_COLUMNS\",\n            \"tableType\": \"META_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": null,\n            \"remarks\": \"\",\n            \"lastModification\": 2,\n            \"id\": -21,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.InfoMetaTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"INFORMATION_SCHEMA\",\n            \"tableName\": \"TABLE_ALTER_HISTORY\",\n            \"tableType\": \"STANDARD_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": \"CREATE CACHED TABLE INFORMATION_SCHEMA.TABLE_ALTER_HISTORY(\\n    ID INT NOT NULL,\\n    VERSION INT NOT NULL,\\n    ALTER_TYPE INT,\\n    COLUMNS VARCHAR\\n)\",\n            \"remarks\": \"\",\n            \"lastModification\": 0,\n            \"id\": 1,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.StandardTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"INFORMATION_SCHEMA\",\n            \"tableName\": \"SCHEMAS\",\n            \"tableType\": \"META_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": null,\n            \"remarks\": \"\",\n            \"lastModification\": 2,\n            \"id\": -14,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.InfoMetaTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"INFORMATION_SCHEMA\",\n            \"tableName\": \"CONSTANTS\",\n            \"tableType\": \"META_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": null,\n            \"remarks\": \"\",\n            \"lastModification\": 2,\n            \"id\": -22,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.InfoMetaTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"INFORMATION_SCHEMA\",\n            \"tableName\": \"SEQUENCES\",\n            \"tableType\": \"META_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": null,\n            \"remarks\": \"\",\n            \"lastModification\": 2,\n            \"id\": -9,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.InfoMetaTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"INFORMATION_SCHEMA\",\n            \"tableName\": \"RIGHTS\",\n            \"tableType\": \"META_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": null,\n            \"remarks\": \"\",\n            \"lastModification\": 2,\n            \"id\": -12,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.InfoMetaTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"INFORMATION_SCHEMA\",\n            \"tableName\": \"SERVICES\",\n            \"tableType\": \"META_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": null,\n            \"remarks\": \"\",\n            \"lastModification\": 2,\n            \"id\": -30,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.InfoMetaTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"INFORMATION_SCHEMA\",\n            \"tableName\": \"TRIGGERS\",\n            \"tableType\": \"META_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": null,\n            \"remarks\": \"\",\n            \"lastModification\": 2,\n            \"id\": -24,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.InfoMetaTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"INFORMATION_SCHEMA\",\n            \"tableName\": \"CATALOGS\",\n            \"tableType\": \"META_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": null,\n            \"remarks\": \"\",\n            \"lastModification\": 2,\n            \"id\": -6,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.InfoMetaTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"INFORMATION_SCHEMA\",\n            \"tableName\": \"CROSS_REFERENCES\",\n            \"tableType\": \"META_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": null,\n            \"remarks\": \"\",\n            \"lastModification\": 2,\n            \"id\": -19,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.InfoMetaTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"INFORMATION_SCHEMA\",\n            \"tableName\": \"SETTINGS\",\n            \"tableType\": \"META_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": null,\n            \"remarks\": \"\",\n            \"lastModification\": 9223372036854776000,\n            \"id\": -7,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.InfoMetaTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"INFORMATION_SCHEMA\",\n            \"tableName\": \"FUNCTION_ALIASES\",\n            \"tableType\": \"META_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": null,\n            \"remarks\": \"\",\n            \"lastModification\": 2,\n            \"id\": -13,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.InfoMetaTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"INFORMATION_SCHEMA\",\n            \"tableName\": \"VIEWS\",\n            \"tableType\": \"META_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": null,\n            \"remarks\": \"\",\n            \"lastModification\": 2,\n            \"id\": -18,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.InfoMetaTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"INFORMATION_SCHEMA\",\n            \"tableName\": \"TYPE_INFO\",\n            \"tableType\": \"META_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": null,\n            \"remarks\": \"\",\n            \"lastModification\": 2,\n            \"id\": -5,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.InfoMetaTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"INFORMATION_SCHEMA\",\n            \"tableName\": \"CONSTRAINTS\",\n            \"tableType\": \"META_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": null,\n            \"remarks\": \"\",\n            \"lastModification\": 2,\n            \"id\": -20,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.InfoMetaTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"INFORMATION_SCHEMA\",\n            \"tableName\": \"COLUMNS\",\n            \"tableType\": \"META_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": null,\n            \"remarks\": \"\",\n            \"lastModification\": 2,\n            \"id\": -2,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.InfoMetaTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"INFORMATION_SCHEMA\",\n            \"tableName\": \"LOCKS\",\n            \"tableType\": \"META_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": null,\n            \"remarks\": \"\",\n            \"lastModification\": 9223372036854776000,\n            \"id\": -26,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.InfoMetaTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"INFORMATION_SCHEMA\",\n            \"tableName\": \"DOMAINS\",\n            \"tableType\": \"META_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": null,\n            \"remarks\": \"\",\n            \"lastModification\": 2,\n            \"id\": -23,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.InfoMetaTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"INFORMATION_SCHEMA\",\n            \"tableName\": \"COLUMN_PRIVILEGES\",\n            \"tableType\": \"META_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": null,\n            \"remarks\": \"\",\n            \"lastModification\": 2,\n            \"id\": -16,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.InfoMetaTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"INFORMATION_SCHEMA\",\n            \"tableName\": \"HELP\",\n            \"tableType\": \"META_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": null,\n            \"remarks\": \"\",\n            \"lastModification\": 2,\n            \"id\": -8,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.InfoMetaTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"INFORMATION_SCHEMA\",\n            \"tableName\": \"SESSION_STATE\",\n            \"tableType\": \"META_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": null,\n            \"remarks\": \"\",\n            \"lastModification\": 9223372036854776000,\n            \"id\": -27,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.InfoMetaTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"INFORMATION_SCHEMA\",\n            \"tableName\": \"DB_OBJECTS\",\n            \"tableType\": \"META_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": null,\n            \"remarks\": \"\",\n            \"lastModification\": 2,\n            \"id\": -29,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.InfoMetaTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"INFORMATION_SCHEMA\",\n            \"tableName\": \"TABLE_PRIVILEGES\",\n            \"tableType\": \"META_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": null,\n            \"remarks\": \"\",\n            \"lastModification\": 2,\n            \"id\": -15,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.InfoMetaTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"INFORMATION_SCHEMA\",\n            \"tableName\": \"DATABASES\",\n            \"tableType\": \"META_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": null,\n            \"remarks\": \"\",\n            \"lastModification\": 2,\n            \"id\": -28,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.InfoMetaTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"INFORMATION_SCHEMA\",\n            \"tableName\": \"TABLE_TYPES\",\n            \"tableType\": \"META_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": null,\n            \"remarks\": \"\",\n            \"lastModification\": 2,\n            \"id\": -4,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.InfoMetaTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"INFORMATION_SCHEMA\",\n            \"tableName\": \"TABLES\",\n            \"tableType\": \"META_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": null,\n            \"remarks\": \"\",\n            \"lastModification\": 2,\n            \"id\": -1,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.InfoMetaTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"INFORMATION_SCHEMA\",\n            \"tableName\": \"ROLES\",\n            \"tableType\": \"META_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": null,\n            \"remarks\": \"\",\n            \"lastModification\": 2,\n            \"id\": -11,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.InfoMetaTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"INFORMATION_SCHEMA\",\n            \"tableName\": \"SESSIONS\",\n            \"tableType\": \"META_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": null,\n            \"remarks\": \"\",\n            \"lastModification\": 9223372036854776000,\n            \"id\": -25,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.InfoMetaTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"INFORMATION_SCHEMA\",\n            \"tableName\": \"USERS\",\n            \"tableType\": \"META_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": null,\n            \"remarks\": \"\",\n            \"lastModification\": 2,\n            \"id\": -10,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.InfoMetaTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"INFORMATION_SCHEMA\",\n            \"tableName\": \"COLLATIONS\",\n            \"tableType\": \"META_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": null,\n            \"remarks\": \"\",\n            \"lastModification\": 2,\n            \"id\": -17,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.InfoMetaTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"INFORMATION_SCHEMA\",\n            \"tableName\": \"INDEXES\",\n            \"tableType\": \"META_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": null,\n            \"remarks\": \"\",\n            \"lastModification\": 2,\n            \"id\": -3,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.InfoMetaTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"S1\",\n            \"tableName\": \"T_TTTS\",\n            \"tableType\": \"STANDARD_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": \"CREATE CACHED TABLE S1.T_TTTS(\\n    ID INTEGER NOT NULL,\\n    TITLE VARCHAR(1024),\\n    IAMGES VARCHAR(2048),\\n    PRICE BIGINT,\\n    CREATE_TIME TIMESTAMP\\n)\",\n            \"remarks\": \"\",\n            \"lastModification\": 0,\n            \"id\": 11,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.StandardTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"S1\",\n            \"tableName\": \"T_GOODS\",\n            \"tableType\": \"STANDARD_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": \"CREATE CACHED TABLE S1.T_GOODS(\\n    ID INTEGER DEFAULT (NEXT VALUE FOR S1.SYSTEM_SEQUENCE_2BB1896D_9E1D_48C8_8D66_E6EAA37061B8) NOT NULL NULL_TO_DEFAULT SEQUENCE S1.SYSTEM_SEQUENCE_2BB1896D_9E1D_48C8_8D66_E6EAA37061B8,\\n    TITLE VARCHAR(1024),\\n    IAMGES VARCHAR(2048),\\n    PRICE BIGINT,\\n    CREATE_TIME TIMESTAMP\\n)\",\n            \"remarks\": \"\",\n            \"lastModification\": 0,\n            \"id\": 9,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.StandardTable\"\n        },\n        {\n            \"tableCatalog\": \"DD\",\n            \"tableSchema\": \"PERFORMANCE_SCHEMA\",\n            \"tableName\": \"QUERY_STATISTICS\",\n            \"tableType\": \"META_TABLE\",\n            \"storageType\": \"CACHED\",\n            \"sql\": null,\n            \"remarks\": \"\",\n            \"lastModification\": 2,\n            \"id\": -1,\n            \"typeName\": null,\n            \"tableClass\": \"org.lealone.db.table.PerfMetaTable\"\n        }\n    ],\n    \"timestamp\": 1706756731150,\n    \"executeTime\": 184\n}",
  "description" : null,
  "requestBodyDefinition" : null,
  "responseBodyDefinition" : null
}
================================
import db;

// select * from DD.S1.T_GOODS
// select * from DD.S3.t_user
return db.select("""
     select * from INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE ='STANDARD_TABLE'
""") 